Skip Headers

Oracle® Database SQL Reference 10g Release 2 (10.2) Part Number B14200-02 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# TIMESTAMP_TO_SCN

Syntax

Description of the illustration timestamp_to_scn.gif

Purpose

`TIMESTAMP_TO_SCN` takes as an argument a timestamp value and returns the approximate system change number (SCN) associated with that timestamp. The returned value is of datatype `NUMBER`. This function is useful any time you want to know the SCN associated with a particular timestamp.

See Also: SCN_TO_TIMESTAMP for information on converting SCNs to timestamp

Examples

The following example inserts a row into the `oe.orders` table and then uses `TIMESTAMP_TO_SCN` to determine the system change number of the insert operation. (The actual SCN returned will differ on each system.)

    INSERT INTO orders (order_id, order_date, customer_id, order_total)
       VALUES (5000, SYSTIMESTAMP, 188, 2345);
    1 row created.

    COMMIT;
    Commit complete.

    SELECT TIMESTAMP_TO_SCN(order_date) FROM orders
       WHERE order_id = 5000;

    TIMESTAMP_TO_SCN(ORDER_DATE)
    ----------------------------
                          574100